﻿PRINT 'INSERTING DATA INTO TABLE Departamente'
ALTER TABLE [Departamente] NOCHECK CONSTRAINT ALL
SET IDENTITY_INSERT [Departamente] ON
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('01','Primul departament',1,1,0,1,0)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('02','Al Doilea Departament',1,2,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('011','Primul dep cu fii',1,3,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('133','Departamentul lui peste',NULL,4,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('03','Trei',NULL,5,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('04','Patru',NULL,6,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('134','Departamentul lui Marin',1,8,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('135','Departamentul lui Mos Craciun ',1,9,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('136','Departamentul lu Eniko',1,10,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('137','Departamentul lui Betty',NULL,11,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('140','Departamentull lui Korina',1,12,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('123','Trilu lilu crococdilu',1,13,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('32','sase',NULL,14,0,1,1)
INSERT INTO [Departamente] ([Cod],[Nume],[Activ],[IDDepartament],[CodUnitate],[IDTipDepartament],[IDDepartParinte]) VALUES ('03','tata',1,15,0,2,8)
SET IDENTITY_INSERT [Departamente] OFF
ALTER TABLE [Departamente] CHECK CONSTRAINT ALL